<?php
/*
create table test(user varchar(100), password varchar(100));
insert into test(user,password) values('patrick', AES_ENCRYPT('password', 'mykey'));
select * from test where user = 'patrick';
update test set password = AES_ENCRYPT('new password', 'mykey') where user = 'patrick';
select AES_DECRYPT(password, 'mykey') from test where user = 'patrick';
 *
 *
 $mysqli=new mysqli('localhost','bnatwork','T7dHAzvWWStZzcC7','bnatwork');
 if($result=$mysqli->query("SELECT * FROM SiteMenu, TagMenu, PluginComponent WHERE menuSITE = (SELECT siteID FROM Site WHERE siteNAME = 'bnatwork') AND menuID = tmMENUID AND tmCOMPONENT = pcNAME ORDER BY menuINDEX, tmINDEX")){  //echo'For the state of AL, there are '.$result->num_rows.' cities.<br/>';
  while($row=$result->fetch_object()){
	if ($row->menuID != $compare_c){
		if($compare_c!=-1)
		{
		echo '</ul></div>';
		}

	echo '<div class="section"><h3>'. $row->menuNAME .'</h3><ul>';
	$compare_c = $row->menuID;
}*/
?>